Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 9994 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 2448 |
| Duplicate rows (%) | 24.5% |
| Total size in memory | 674.9 KiB |
| Average record size in memory | 69.1 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 5 |
| Dataset has 2448 (24.5%) duplicate rows | Duplicates |
Order Date is highly overall correlated with Ship Date | High correlation |
Ship Date is highly overall correlated with Order Date | High correlation |
Sales is highly overall correlated with Profit | High correlation |
Discount is highly overall correlated with Profit | High correlation |
Profit is highly overall correlated with Sales and 1 other fields | High correlation |
Product ID_id is highly overall correlated with Category and 1 other fields | High correlation |
Category is highly overall correlated with Product ID_id and 1 other fields | High correlation |
Sub-Category is highly overall correlated with Product ID_id and 1 other fields | High correlation |
Discount has 4798 (48.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-04-11 17:37:04.553201 |
|---|---|
| Analysis finished | 2023-04-11 17:37:14.365236 |
| Duration | 9.81 seconds |
| Software version | ydata-profiling vv4.1.2 |
| Download configuration | config.json |
Order Date
Real number (ℝ)
| Distinct | 1237 |
|---|---|
| Distinct (%) | 12.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14619.748 |
| Minimum | 13887.072 |
|---|---|
| Maximum | 15145.92 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 13887.072 |
|---|---|
| 5-th percentile | 14006.866 |
| Q1 | 14323.392 |
| median | 14668.992 |
| Q3 | 14947.2 |
| 95-th percentile | 15117.408 |
| Maximum | 15145.92 |
| Range | 1258.848 |
| Interquartile range (IQR) | 623.808 |
Descriptive statistics
| Standard deviation | 363.30282 |
|---|---|
| Coefficient of variation (CV) | 0.024850142 |
| Kurtosis | -1.1532496 |
| Mean | 14619.748 |
| Median Absolute Deviation (MAD) | 304.992 |
| Skewness | -0.26783343 |
| Sum | 1.4610976 × 108 |
| Variance | 131988.94 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14730.336 | 38 | 0.4% |
| 15043.104 | 36 | 0.4% |
| 14787.36 | 35 | 0.4% |
| 15120.864 | 34 | 0.3% |
| 15121.728 | 34 | 0.3% |
| 15127.776 | 33 | 0.3% |
| 15104.448 | 30 | 0.3% |
| 15126.912 | 30 | 0.3% |
| 15049.152 | 29 | 0.3% |
| 14814.144 | 28 | 0.3% |
| Other values (1227) | 9667 |
| Value | Count | Frequency (%) |
| 13887.072 | 1 | < 0.1% |
| 13887.936 | 3 | < 0.1% |
| 13888.8 | 1 | < 0.1% |
| 13889.664 | 9 | |
| 13890.528 | 2 | < 0.1% |
| 13892.256 | 2 | < 0.1% |
| 13893.12 | 2 | < 0.1% |
| 13893.984 | 1 | < 0.1% |
| 13895.712 | 11 | |
| 13896.576 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 15145.92 | 7 | 0.1% |
| 15145.056 | 12 | |
| 15144.192 | 19 | |
| 15143.328 | 2 | < 0.1% |
| 15142.464 | 4 | < 0.1% |
| 15141.6 | 23 | |
| 15140.736 | 16 | |
| 15139.872 | 15 | |
| 15139.008 | 27 | |
| 15138.144 | 11 |
Ship Date
Real number (ℝ)
| Distinct | 1334 |
|---|---|
| Distinct (%) | 13.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14623.168 |
| Minimum | 13890.528 |
|---|---|
| Maximum | 15151.104 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 13890.528 |
|---|---|
| 5-th percentile | 14011.186 |
| Q1 | 14326.848 |
| median | 14671.584 |
| Q3 | 14950.656 |
| 95-th percentile | 15120.864 |
| Maximum | 15151.104 |
| Range | 1260.576 |
| Interquartile range (IQR) | 623.808 |
Descriptive statistics
| Standard deviation | 363.2733 |
|---|---|
| Coefficient of variation (CV) | 0.024842312 |
| Kurtosis | -1.1532138 |
| Mean | 14623.168 |
| Median Absolute Deviation (MAD) | 305.856 |
| Skewness | -0.2678001 |
| Sum | 1.4614394 × 108 |
| Variance | 131967.49 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14502.24 | 35 | 0.4% |
| 15063.84 | 34 | 0.3% |
| 15125.184 | 32 | 0.3% |
| 15112.224 | 32 | 0.3% |
| 15046.56 | 30 | 0.3% |
| 15130.368 | 30 | 0.3% |
| 15054.336 | 30 | 0.3% |
| 14105.664 | 27 | 0.3% |
| 15048.288 | 27 | 0.3% |
| 15109.632 | 26 | 0.3% |
| Other values (1324) | 9691 |
| Value | Count | Frequency (%) |
| 13890.528 | 2 | < 0.1% |
| 13891.392 | 4 | |
| 13893.12 | 7 | |
| 13894.848 | 3 | < 0.1% |
| 13895.712 | 2 | < 0.1% |
| 13896.576 | 1 | < 0.1% |
| 13897.44 | 8 | |
| 13898.304 | 1 | < 0.1% |
| 13899.168 | 1 | < 0.1% |
| 13900.032 | 9 |
| Value | Count | Frequency (%) |
| 15151.104 | 2 | < 0.1% |
| 15150.24 | 5 | 0.1% |
| 15149.376 | 7 | 0.1% |
| 15148.512 | 8 | 0.1% |
| 15147.648 | 20 | |
| 15146.784 | 6 | 0.1% |
| 15145.92 | 8 | 0.1% |
| 15145.056 | 12 | |
| 15144.192 | 23 | |
| 15143.328 | 12 |
Ship Mode
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.1 KiB |
| Standard Class | |
|---|---|
| Second Class | |
| First Class | |
| Same Day | 543 |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 12.823094 |
| Min length | 8 |
Characters and Unicode
| Total characters | 128154 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Second Class |
|---|---|
| 2nd row | Second Class |
| 3rd row | Second Class |
| 4th row | Standard Class |
| 5th row | Standard Class |
Common Values
| Value | Count | Frequency (%) |
| Standard Class | 5968 | |
| Second Class | 1945 | 19.5% |
| First Class | 1538 | 15.4% |
| Same Day | 543 | 5.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| class | 9451 | |
| standard | 5968 | |
| second | 1945 | 9.7% |
| first | 1538 | 7.7% |
| same | 543 | 2.7% |
| day | 543 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 22473 | |
| s | 20440 | |
| d | 13881 | |
| 9994 | ||
| l | 9451 | |
| C | 9451 | |
| S | 8456 | 6.6% |
| n | 7913 | 6.2% |
| r | 7506 | 5.9% |
| t | 7506 | 5.9% |
| Other values (8) | 11083 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 98172 | |
| Uppercase Letter | 19988 | 15.6% |
| Space Separator | 9994 | 7.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 22473 | |
| s | 20440 | |
| d | 13881 | |
| l | 9451 | |
| n | 7913 | 8.1% |
| r | 7506 | 7.6% |
| t | 7506 | 7.6% |
| e | 2488 | 2.5% |
| c | 1945 | 2.0% |
| o | 1945 | 2.0% |
| Other values (3) | 2624 | 2.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 9451 | |
| S | 8456 | |
| F | 1538 | 7.7% |
| D | 543 | 2.7% |
Space Separator
| Value | Count | Frequency (%) |
| 9994 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 118160 | |
| Common | 9994 | 7.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 22473 | |
| s | 20440 | |
| d | 13881 | |
| l | 9451 | |
| C | 9451 | |
| S | 8456 | 7.2% |
| n | 7913 | 6.7% |
| r | 7506 | 6.4% |
| t | 7506 | 6.4% |
| e | 2488 | 2.1% |
| Other values (7) | 8595 | 7.3% |
Common
| Value | Count | Frequency (%) |
| 9994 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 128154 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 22473 | |
| s | 20440 | |
| d | 13881 | |
| 9994 | ||
| l | 9451 | |
| C | 9451 | |
| S | 8456 | 6.6% |
| n | 7913 | 6.2% |
| r | 7506 | 5.9% |
| t | 7506 | 5.9% |
| Other values (8) | 11083 |
Segment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.0 KiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.8374024 |
| Min length | 8 |
Characters and Unicode
| Total characters | 88321 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Consumer |
|---|---|
| 2nd row | Consumer |
| 3rd row | Corporate |
| 4th row | Consumer |
| 5th row | Consumer |
Common Values
| Value | Count | Frequency (%) |
| Consumer | 5191 | |
| Corporate | 3020 | |
| Home Office | 1783 | 17.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| consumer | 5191 | |
| corporate | 3020 | |
| home | 1783 | 15.1% |
| office | 1783 | 15.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| C | 8211 | |
| m | 6974 | |
| n | 5191 | 5.9% |
| s | 5191 | 5.9% |
| u | 5191 | 5.9% |
| f | 3566 | 4.0% |
| t | 3020 | 3.4% |
| Other values (7) | 14955 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 74761 | |
| Uppercase Letter | 11777 | 13.3% |
| Space Separator | 1783 | 2.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| m | 6974 | |
| n | 5191 | 6.9% |
| s | 5191 | 6.9% |
| u | 5191 | 6.9% |
| f | 3566 | 4.8% |
| t | 3020 | 4.0% |
| p | 3020 | 4.0% |
| Other values (3) | 6586 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 8211 | |
| H | 1783 | 15.1% |
| O | 1783 | 15.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1783 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 86538 | |
| Common | 1783 | 2.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| C | 8211 | |
| m | 6974 | |
| n | 5191 | 6.0% |
| s | 5191 | 6.0% |
| u | 5191 | 6.0% |
| f | 3566 | 4.1% |
| t | 3020 | 3.5% |
| Other values (6) | 13172 |
Common
| Value | Count | Frequency (%) |
| 1783 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 88321 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| C | 8211 | |
| m | 6974 | |
| n | 5191 | 5.9% |
| s | 5191 | 5.9% |
| u | 5191 | 5.9% |
| f | 3566 | 4.0% |
| t | 3020 | 3.4% |
| Other values (7) | 14955 |
Region
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.1 KiB |
| West | |
|---|---|
| East | |
| Central | |
| South |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 4.8594156 |
| Min length | 4 |
Characters and Unicode
| Total characters | 48565 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | South |
|---|---|
| 2nd row | South |
| 3rd row | West |
| 4th row | South |
| 5th row | South |
Common Values
| Value | Count | Frequency (%) |
| West | 3203 | |
| East | 2848 | |
| Central | 2323 | |
| South | 1620 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| west | 3203 | |
| east | 2848 | |
| central | 2323 | |
| south | 1620 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| W | 3203 | 6.6% |
| E | 2848 | 5.9% |
| C | 2323 | 4.8% |
| n | 2323 | 4.8% |
| r | 2323 | 4.8% |
| l | 2323 | 4.8% |
| Other values (4) | 6480 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 38571 | |
| Uppercase Letter | 9994 | 20.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| n | 2323 | 6.0% |
| r | 2323 | 6.0% |
| l | 2323 | 6.0% |
| o | 1620 | 4.2% |
| u | 1620 | 4.2% |
| h | 1620 | 4.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 3203 | |
| E | 2848 | |
| C | 2323 | |
| S | 1620 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 48565 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| W | 3203 | 6.6% |
| E | 2848 | 5.9% |
| C | 2323 | 4.8% |
| n | 2323 | 4.8% |
| r | 2323 | 4.8% |
| l | 2323 | 4.8% |
| Other values (4) | 6480 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 48565 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| W | 3203 | 6.6% |
| E | 2848 | 5.9% |
| C | 2323 | 4.8% |
| n | 2323 | 4.8% |
| r | 2323 | 4.8% |
| l | 2323 | 4.8% |
| Other values (4) | 6480 |
Category
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.0 KiB |
| Office Supplies | |
|---|---|
| Furniture | |
| Technology |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 12.802582 |
| Min length | 9 |
Characters and Unicode
| Total characters | 127949 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Furniture |
|---|---|
| 2nd row | Furniture |
| 3rd row | Office Supplies |
| 4th row | Furniture |
| 5th row | Office Supplies |
Common Values
| Value | Count | Frequency (%) |
| Office Supplies | 6026 | |
| Furniture | 2121 | 21.2% |
| Technology | 1847 | 18.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| office | 6026 | |
| supplies | 6026 | |
| furniture | 2121 | 13.2% |
| technology | 1847 | 11.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | 8.0% |
| c | 7873 | 6.2% |
| l | 7873 | 6.2% |
| O | 6026 | 4.7% |
| s | 6026 | 4.7% |
| S | 6026 | 4.7% |
| Other values (10) | 29560 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 105903 | |
| Uppercase Letter | 16020 | 12.5% |
| Space Separator | 6026 | 4.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | |
| c | 7873 | |
| l | 7873 | |
| s | 6026 | 5.7% |
| r | 4242 | 4.0% |
| n | 3968 | 3.7% |
| Other values (5) | 11356 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 6026 | |
| S | 6026 | |
| F | 2121 | 13.2% |
| T | 1847 | 11.5% |
Space Separator
| Value | Count | Frequency (%) |
| 6026 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 121923 | |
| Common | 6026 | 4.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | |
| c | 7873 | 6.5% |
| l | 7873 | 6.5% |
| O | 6026 | 4.9% |
| s | 6026 | 4.9% |
| S | 6026 | 4.9% |
| Other values (9) | 23534 |
Common
| Value | Count | Frequency (%) |
| 6026 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 127949 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | 8.0% |
| c | 7873 | 6.2% |
| l | 7873 | 6.2% |
| O | 6026 | 4.7% |
| s | 6026 | 4.7% |
| S | 6026 | 4.7% |
| Other values (10) | 29560 |
Sub-Category
Categorical
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.6 KiB |
| Binders | |
|---|---|
| Paper | |
| Furnishings | |
| Phones | |
| Storage | |
| Other values (12) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 7.191715 |
| Min length | 3 |
Characters and Unicode
| Total characters | 71874 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Bookcases |
|---|---|
| 2nd row | Chairs |
| 3rd row | Labels |
| 4th row | Tables |
| 5th row | Storage |
Common Values
| Value | Count | Frequency (%) |
| Binders | 1523 | |
| Paper | 1370 | |
| Furnishings | 957 | |
| Phones | 889 | |
| Storage | 846 | |
| Art | 796 | |
| Accessories | 775 | |
| Chairs | 617 | |
| Appliances | 466 | 4.7% |
| Labels | 364 | 3.6% |
| Other values (7) | 1391 |
Length
| Value | Count | Frequency (%) |
| binders | 1523 | |
| paper | 1370 | |
| furnishings | 957 | |
| phones | 889 | |
| storage | 846 | |
| art | 796 | |
| accessories | 775 | |
| chairs | 617 | |
| appliances | 466 | 4.7% |
| labels | 364 | 3.6% |
| Other values (7) | 1391 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | 10.0% |
| i | 5668 | 7.9% |
| n | 5378 | 7.5% |
| a | 4542 | 6.3% |
| o | 3288 | 4.6% |
| p | 3004 | 4.2% |
| h | 2578 | 3.6% |
| c | 2359 | 3.3% |
| Other values (18) | 19084 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 61880 | |
| Uppercase Letter | 9994 | 13.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | |
| i | 5668 | |
| n | 5378 | |
| a | 4542 | |
| o | 3288 | 5.3% |
| p | 3004 | 4.9% |
| h | 2578 | 4.2% |
| c | 2359 | 3.8% |
| Other values (8) | 9090 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 2259 | |
| A | 2037 | |
| B | 1751 | |
| F | 1174 | |
| S | 1036 | |
| C | 685 | 6.9% |
| L | 364 | 3.6% |
| T | 319 | 3.2% |
| E | 254 | 2.5% |
| M | 115 | 1.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 71874 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | 10.0% |
| i | 5668 | 7.9% |
| n | 5378 | 7.5% |
| a | 4542 | 6.3% |
| o | 3288 | 4.6% |
| p | 3004 | 4.2% |
| h | 2578 | 3.6% |
| c | 2359 | 3.3% |
| Other values (18) | 19084 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 71874 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | 10.0% |
| i | 5668 | 7.9% |
| n | 5378 | 7.5% |
| a | 4542 | 6.3% |
| o | 3288 | 4.6% |
| p | 3004 | 4.2% |
| h | 2578 | 3.6% |
| c | 2359 | 3.3% |
| Other values (18) | 19084 |
Sales
Real number (ℝ)
| Distinct | 5825 |
|---|---|
| Distinct (%) | 58.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 229.858 |
| Minimum | 0.444 |
|---|---|
| Maximum | 22638.48 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0.444 |
|---|---|
| 5-th percentile | 4.98 |
| Q1 | 17.28 |
| median | 54.49 |
| Q3 | 209.94 |
| 95-th percentile | 956.98425 |
| Maximum | 22638.48 |
| Range | 22638.036 |
| Interquartile range (IQR) | 192.66 |
Descriptive statistics
| Standard deviation | 623.2451 |
|---|---|
| Coefficient of variation (CV) | 2.7114353 |
| Kurtosis | 305.31175 |
| Mean | 229.858 |
| Median Absolute Deviation (MAD) | 45.406 |
| Skewness | 12.972752 |
| Sum | 2297200.9 |
| Variance | 388434.46 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12.96 | 56 | 0.6% |
| 19.44 | 39 | 0.4% |
| 15.552 | 39 | 0.4% |
| 25.92 | 36 | 0.4% |
| 10.368 | 36 | 0.4% |
| 32.4 | 28 | 0.3% |
| 17.94 | 21 | 0.2% |
| 6.48 | 21 | 0.2% |
| 20.736 | 19 | 0.2% |
| 14.94 | 17 | 0.2% |
| Other values (5815) | 9682 |
| Value | Count | Frequency (%) |
| 0.444 | 1 | < 0.1% |
| 0.556 | 1 | < 0.1% |
| 0.836 | 1 | < 0.1% |
| 0.852 | 1 | < 0.1% |
| 0.876 | 1 | < 0.1% |
| 0.898 | 1 | < 0.1% |
| 0.984 | 1 | < 0.1% |
| 0.99 | 1 | < 0.1% |
| 1.044 | 1 | < 0.1% |
| 1.08 | 3 |
| Value | Count | Frequency (%) |
| 22638.48 | 1 | |
| 17499.95 | 1 | |
| 13999.96 | 1 | |
| 11199.968 | 1 | |
| 10499.97 | 1 | |
| 9892.74 | 1 | |
| 9449.95 | 1 | |
| 9099.93 | 1 | |
| 8749.95 | 1 | |
| 8399.976 | 1 |
Quantity
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.7895737 |
| Minimum | 1 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 8 |
| Maximum | 14 |
| Range | 13 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.2251097 |
|---|---|
| Coefficient of variation (CV) | 0.58716622 |
| Kurtosis | 1.9918894 |
| Mean | 3.7895737 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.2785448 |
| Sum | 37873 |
| Variance | 4.9511131 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 2409 | |
| 2 | 2402 | |
| 5 | 1230 | |
| 4 | 1191 | |
| 1 | 899 | 9.0% |
| 7 | 606 | 6.1% |
| 6 | 572 | 5.7% |
| 9 | 258 | 2.6% |
| 8 | 257 | 2.6% |
| 10 | 57 | 0.6% |
| Other values (4) | 113 | 1.1% |
| Value | Count | Frequency (%) |
| 1 | 899 | 9.0% |
| 2 | 2402 | |
| 3 | 2409 | |
| 4 | 1191 | |
| 5 | 1230 | |
| 6 | 572 | 5.7% |
| 7 | 606 | 6.1% |
| 8 | 257 | 2.6% |
| 9 | 258 | 2.6% |
| 10 | 57 | 0.6% |
| Value | Count | Frequency (%) |
| 14 | 29 | 0.3% |
| 13 | 27 | 0.3% |
| 12 | 23 | 0.2% |
| 11 | 34 | 0.3% |
| 10 | 57 | 0.6% |
| 9 | 258 | 2.6% |
| 8 | 257 | 2.6% |
| 7 | 606 | |
| 6 | 572 | |
| 5 | 1230 |
Discount
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.15620272 |
| Minimum | 0 |
|---|---|
| Maximum | 0.8 |
| Zeros | 4798 |
| Zeros (%) | 48.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.2 |
| Q3 | 0.2 |
| 95-th percentile | 0.7 |
| Maximum | 0.8 |
| Range | 0.8 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 0.20645197 |
|---|---|
| Coefficient of variation (CV) | 1.3216925 |
| Kurtosis | 2.4095461 |
| Mean | 0.15620272 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | 1.6842947 |
| Sum | 1561.09 |
| Variance | 0.042622415 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4798 | |
| 0.2 | 3657 | |
| 0.7 | 418 | 4.2% |
| 0.8 | 300 | 3.0% |
| 0.3 | 227 | 2.3% |
| 0.4 | 206 | 2.1% |
| 0.6 | 138 | 1.4% |
| 0.1 | 94 | 0.9% |
| 0.5 | 66 | 0.7% |
| 0.15 | 52 | 0.5% |
| Other values (2) | 38 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 4798 | |
| 0.1 | 94 | 0.9% |
| 0.15 | 52 | 0.5% |
| 0.2 | 3657 | |
| 0.3 | 227 | 2.3% |
| 0.32 | 27 | 0.3% |
| 0.4 | 206 | 2.1% |
| 0.45 | 11 | 0.1% |
| 0.5 | 66 | 0.7% |
| 0.6 | 138 | 1.4% |
| Value | Count | Frequency (%) |
| 0.8 | 300 | 3.0% |
| 0.7 | 418 | 4.2% |
| 0.6 | 138 | 1.4% |
| 0.5 | 66 | 0.7% |
| 0.45 | 11 | 0.1% |
| 0.4 | 206 | 2.1% |
| 0.32 | 27 | 0.3% |
| 0.3 | 227 | 2.3% |
| 0.2 | 3657 | |
| 0.15 | 52 | 0.5% |
Profit
Real number (ℝ)
| Distinct | 7287 |
|---|---|
| Distinct (%) | 72.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.656896 |
| Minimum | -6599.978 |
|---|---|
| Maximum | 8399.976 |
| Zeros | 65 |
| Zeros (%) | 0.7% |
| Negative | 1871 |
| Negative (%) | 18.7% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | -6599.978 |
|---|---|
| 5-th percentile | -53.03092 |
| Q1 | 1.72875 |
| median | 8.6665 |
| Q3 | 29.364 |
| 95-th percentile | 168.4704 |
| Maximum | 8399.976 |
| Range | 14999.954 |
| Interquartile range (IQR) | 27.63525 |
Descriptive statistics
| Standard deviation | 234.26011 |
|---|---|
| Coefficient of variation (CV) | 8.1746504 |
| Kurtosis | 397.18851 |
| Mean | 28.656896 |
| Median Absolute Deviation (MAD) | 10.77855 |
| Skewness | 7.5614316 |
| Sum | 286397.02 |
| Variance | 54877.798 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 65 | 0.7% |
| 6.2208 | 43 | 0.4% |
| 9.3312 | 38 | 0.4% |
| 5.4432 | 32 | 0.3% |
| 3.6288 | 32 | 0.3% |
| 15.552 | 26 | 0.3% |
| 12.4416 | 21 | 0.2% |
| 7.2576 | 19 | 0.2% |
| 3.1104 | 18 | 0.2% |
| 9.072 | 11 | 0.1% |
| Other values (7277) | 9689 |
| Value | Count | Frequency (%) |
| -6599.978 | 1 | |
| -3839.9904 | 1 | |
| -3701.8928 | 1 | |
| -3399.98 | 1 | |
| -2929.4845 | 1 | |
| -2639.9912 | 1 | |
| -2287.782 | 1 | |
| -1862.3124 | 1 | |
| -1850.9464 | 1 | |
| -1811.0784 | 1 |
| Value | Count | Frequency (%) |
| 8399.976 | 1 | |
| 6719.9808 | 1 | |
| 5039.9856 | 1 | |
| 4946.37 | 1 | |
| 4630.4755 | 1 | |
| 3919.9888 | 1 | |
| 3177.475 | 1 | |
| 2799.984 | 1 | |
| 2591.9568 | 1 | |
| 2504.2216 | 1 |
Customer ID_id
Real number (ℝ)
| Distinct | 793 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 400.46038 |
| Minimum | 0 |
|---|---|
| Maximum | 792 |
| Zeros | 11 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 39 |
| Q1 | 205.25 |
| median | 405.5 |
| Q3 | 602 |
| 95-th percentile | 753 |
| Maximum | 792 |
| Range | 792 |
| Interquartile range (IQR) | 396.75 |
Descriptive statistics
| Standard deviation | 228.58558 |
|---|---|
| Coefficient of variation (CV) | 0.57080698 |
| Kurtosis | -1.1915803 |
| Mean | 400.46038 |
| Median Absolute Deviation (MAD) | 197.5 |
| Skewness | -0.025462504 |
| Sum | 4002201 |
| Variance | 52251.366 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 787 | 37 | 0.4% |
| 387 | 34 | 0.3% |
| 482 | 34 | 0.3% |
| 606 | 34 | 0.3% |
| 147 | 32 | 0.3% |
| 720 | 32 | 0.3% |
| 349 | 32 | 0.3% |
| 257 | 32 | 0.3% |
| 791 | 31 | 0.3% |
| 275 | 31 | 0.3% |
| Other values (783) | 9665 |
| Value | Count | Frequency (%) |
| 0 | 11 | |
| 1 | 15 | |
| 2 | 12 | |
| 3 | 18 | |
| 4 | 6 | 0.1% |
| 5 | 18 | |
| 6 | 20 | |
| 7 | 12 | |
| 8 | 14 | |
| 9 | 14 |
| Value | Count | Frequency (%) |
| 792 | 9 | 0.1% |
| 791 | 31 | |
| 790 | 12 | 0.1% |
| 789 | 8 | 0.1% |
| 788 | 28 | |
| 787 | 37 | |
| 786 | 18 | |
| 785 | 9 | 0.1% |
| 784 | 8 | 0.1% |
| 783 | 14 | 0.1% |
Product ID_id
Real number (ℝ)
| Distinct | 1862 |
|---|---|
| Distinct (%) | 18.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 898.47238 |
| Minimum | 0 |
|---|---|
| Maximum | 1861 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 90 |
| Q1 | 453 |
| median | 863 |
| Q3 | 1347 |
| 95-th percentile | 1758.35 |
| Maximum | 1861 |
| Range | 1861 |
| Interquartile range (IQR) | 894 |
Descriptive statistics
| Standard deviation | 526.70844 |
|---|---|
| Coefficient of variation (CV) | 0.58622664 |
| Kurtosis | -1.1364991 |
| Mean | 898.47238 |
| Median Absolute Deviation (MAD) | 453 |
| Skewness | 0.056258336 |
| Sum | 8979333 |
| Variance | 277421.79 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1144 | 19 | 0.2% |
| 1569 | 18 | 0.2% |
| 295 | 16 | 0.2% |
| 65 | 15 | 0.2% |
| 1566 | 15 | 0.2% |
| 93 | 15 | 0.2% |
| 1517 | 15 | 0.2% |
| 831 | 14 | 0.1% |
| 694 | 14 | 0.1% |
| 97 | 14 | 0.1% |
| Other values (1852) | 9839 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 3 | < 0.1% |
| 2 | 5 | |
| 3 | 6 | |
| 4 | 2 | < 0.1% |
| 5 | 5 | |
| 6 | 10 | |
| 7 | 5 | |
| 8 | 1 | < 0.1% |
| 9 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 1861 | 9 | |
| 1860 | 2 | < 0.1% |
| 1859 | 3 | < 0.1% |
| 1858 | 5 | |
| 1857 | 3 | < 0.1% |
| 1856 | 7 | |
| 1855 | 7 | |
| 1854 | 5 | |
| 1853 | 1 | < 0.1% |
| 1852 | 4 |
| Order Date | Ship Date | Sales | Quantity | Discount | Profit | Customer ID_id | Product ID_id | Ship Mode | Segment | Region | Category | Sub-Category | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Order Date | 1.000 | 1.000 | -0.002 | -0.000 | -0.004 | 0.001 | -0.038 | 0.001 | 0.039 | 0.036 | 0.060 | 0.000 | 0.000 |
| Ship Date | 1.000 | 1.000 | -0.002 | -0.000 | -0.004 | 0.001 | -0.038 | 0.001 | 0.041 | 0.039 | 0.058 | 0.000 | 0.000 |
| Sales | -0.002 | -0.002 | 1.000 | 0.327 | -0.057 | 0.518 | 0.007 | 0.060 | 0.000 | 0.002 | 0.000 | 0.072 | 0.142 |
| Quantity | -0.000 | -0.000 | 0.327 | 1.000 | -0.001 | 0.234 | 0.019 | -0.010 | 0.000 | 0.012 | 0.000 | 0.000 | 0.000 |
| Discount | -0.004 | -0.004 | -0.057 | -0.001 | 1.000 | -0.543 | 0.017 | -0.116 | 0.027 | 0.005 | 0.294 | 0.377 | 0.353 |
| Profit | 0.001 | 0.001 | 0.518 | 0.234 | -0.543 | 1.000 | -0.005 | 0.177 | 0.005 | 0.000 | 0.021 | 0.056 | 0.130 |
| Customer ID_id | -0.038 | -0.038 | 0.007 | 0.019 | 0.017 | -0.005 | 1.000 | 0.005 | 0.030 | 0.134 | 0.045 | 0.000 | 0.000 |
| Product ID_id | 0.001 | 0.001 | 0.060 | -0.010 | -0.116 | 0.177 | 0.005 | 1.000 | 0.000 | 0.009 | 0.000 | 0.975 | 0.841 |
| Ship Mode | 0.039 | 0.041 | 0.000 | 0.000 | 0.027 | 0.005 | 0.030 | 0.000 | 1.000 | 0.033 | 0.022 | 0.000 | 0.007 |
| Segment | 0.036 | 0.039 | 0.002 | 0.012 | 0.005 | 0.000 | 0.134 | 0.009 | 0.033 | 1.000 | 0.000 | 0.000 | 0.000 |
| Region | 0.060 | 0.058 | 0.000 | 0.000 | 0.294 | 0.021 | 0.045 | 0.000 | 0.022 | 0.000 | 1.000 | 0.000 | 0.000 |
| Category | 0.000 | 0.000 | 0.072 | 0.000 | 0.377 | 0.056 | 0.000 | 0.975 | 0.000 | 0.000 | 0.000 | 1.000 | 0.999 |
| Sub-Category | 0.000 | 0.000 | 0.142 | 0.000 | 0.353 | 0.130 | 0.000 | 0.841 | 0.007 | 0.000 | 0.000 | 0.999 | 1.000 |
| Order Date | Ship Date | Ship Mode | Segment | Region | Category | Sub-Category | Sales | Quantity | Discount | Profit | Customer ID_id | Product ID_id | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 14785.632 | 14788.224 | Second Class | Consumer | South | Furniture | Bookcases | 261.9600 | 2 | 0.00 | 41.9136 | 143 | 12 |
| 1 | 14785.632 | 14788.224 | Second Class | Consumer | South | Furniture | Chairs | 731.9400 | 3 | 0.00 | 219.5820 | 143 | 55 |
| 2 | 14656.896 | 14660.352 | Second Class | Corporate | West | Office Supplies | Labels | 14.6200 | 2 | 0.00 | 6.8714 | 237 | 946 |
| 3 | 14445.216 | 14451.264 | Standard Class | Consumer | South | Furniture | Tables | 957.5775 | 5 | 0.45 | -383.0310 | 705 | 319 |
| 4 | 14445.216 | 14451.264 | Standard Class | Consumer | South | Office Supplies | Storage | 22.3680 | 2 | 0.20 | 2.5164 | 705 | 1316 |
| 5 | 14022.720 | 14027.040 | Standard Class | Consumer | West | Furniture | Furnishings | 48.8600 | 7 | 0.00 | 14.1694 | 88 | 185 |
| 6 | 14022.720 | 14027.040 | Standard Class | Consumer | West | Office Supplies | Art | 7.2800 | 4 | 0.00 | 1.9656 | 88 | 562 |
| 7 | 14022.720 | 14027.040 | Standard Class | Consumer | West | Technology | Phones | 907.1520 | 6 | 0.20 | 90.7152 | 88 | 1761 |
| 8 | 14022.720 | 14027.040 | Standard Class | Consumer | West | Office Supplies | Binders | 18.5040 | 3 | 0.20 | 5.7825 | 88 | 794 |
| 9 | 14022.720 | 14027.040 | Standard Class | Consumer | West | Office Supplies | Appliances | 114.9000 | 5 | 0.00 | 34.4700 | 88 | 437 |
| Order Date | Ship Date | Ship Mode | Segment | Region | Category | Sub-Category | Sales | Quantity | Discount | Profit | Customer ID_id | Product ID_id | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9984 | 14318.208 | 14323.392 | Standard Class | Consumer | East | Office Supplies | Labels | 31.500 | 10 | 0.0 | 15.1200 | 238 | 995 |
| 9985 | 14318.208 | 14323.392 | Standard Class | Consumer | East | Office Supplies | Supplies | 55.600 | 4 | 0.0 | 16.1240 | 238 | 1425 |
| 9986 | 14751.072 | 14754.528 | Standard Class | Consumer | West | Technology | Accessories | 36.240 | 1 | 0.0 | 15.2208 | 520 | 1558 |
| 9987 | 15108.768 | 15112.224 | Standard Class | Corporate | South | Technology | Accessories | 79.990 | 1 | 0.0 | 28.7964 | 617 | 1498 |
| 9988 | 15108.768 | 15112.224 | Standard Class | Corporate | South | Technology | Phones | 206.100 | 5 | 0.0 | 55.6470 | 617 | 1826 |
| 9989 | 13902.624 | 13904.352 | Second Class | Consumer | South | Furniture | Furnishings | 25.248 | 3 | 0.2 | 4.1028 | 737 | 200 |
| 9990 | 14880.672 | 14884.992 | Standard Class | Consumer | West | Furniture | Furnishings | 91.960 | 2 | 0.0 | 15.6332 | 190 | 164 |
| 9991 | 14880.672 | 14884.992 | Standard Class | Consumer | West | Technology | Phones | 258.576 | 2 | 0.2 | 19.3932 | 190 | 1816 |
| 9992 | 14880.672 | 14884.992 | Standard Class | Consumer | West | Office Supplies | Paper | 29.600 | 4 | 0.0 | 13.3200 | 190 | 1247 |
| 9993 | 14938.560 | 14942.880 | Second Class | Consumer | West | Office Supplies | Appliances | 243.160 | 2 | 0.0 | 72.9480 | 130 | 433 |
Most frequently occurring
| Order Date | Ship Date | Ship Mode | Segment | Region | Category | Sub-Category | Sales | Quantity | Discount | Profit | Customer ID_id | Product ID_id | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2300 | 13982.112 | 13985.568 | Standard Class | Home Office | East | Furniture | Chairs | 281.372 | 2 | 0.3 | -12.0588 | 449 | 99 | 2 |
| 0 | 13982.112 | 13985.568 | First Class | Consumer | Central | Furniture | Accessories | 281.372 | 2 | 0.3 | -12.0588 | 449 | 99 | 0 |
| 1 | 13982.112 | 13985.568 | First Class | Consumer | Central | Furniture | Appliances | 281.372 | 2 | 0.3 | -12.0588 | 449 | 99 | 0 |
| 2 | 13982.112 | 13985.568 | First Class | Consumer | Central | Furniture | Art | 281.372 | 2 | 0.3 | -12.0588 | 449 | 99 | 0 |
| 3 | 13982.112 | 13985.568 | First Class | Consumer | Central | Furniture | Binders | 281.372 | 2 | 0.3 | -12.0588 | 449 | 99 | 0 |
| 4 | 13982.112 | 13985.568 | First Class | Consumer | Central | Furniture | Bookcases | 281.372 | 2 | 0.3 | -12.0588 | 449 | 99 | 0 |
| 5 | 13982.112 | 13985.568 | First Class | Consumer | Central | Furniture | Chairs | 281.372 | 2 | 0.3 | -12.0588 | 449 | 99 | 0 |
| 6 | 13982.112 | 13985.568 | First Class | Consumer | Central | Furniture | Copiers | 281.372 | 2 | 0.3 | -12.0588 | 449 | 99 | 0 |
| 7 | 13982.112 | 13985.568 | First Class | Consumer | Central | Furniture | Envelopes | 281.372 | 2 | 0.3 | -12.0588 | 449 | 99 | 0 |
| 8 | 13982.112 | 13985.568 | First Class | Consumer | Central | Furniture | Fasteners | 281.372 | 2 | 0.3 | -12.0588 | 449 | 99 | 0 |